LoanInterest[zh_TW].r1-print 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <DocRoot>
  3. <Parameters/>
  4. <DataSources>
  5. <Reference name="LoanInterestHeaderTDQuery" alias.zh_CN="借款利息单单据头套打Query" alias="#1" desc.zh_CN="借款利息单单据头套打Query" desc="#1" info="::/com/kingdee/eas/fm/fin/app/LoanInterestHeaderTDQuery.bos-query" alias.zh_TW="借款利息單單據頭套打Query" desc.zh_TW="借款利息單單據頭套打Query"/>
  6. <Reference name="LoanInterestEntryTDQuery" alias.zh_CN="借款利息单分录套打Query" alias="#1" desc.zh_CN="借款利息单分录套打Query" desc="#1" info="::/com/kingdee/eas/fm/fin/app/LoanInterestEntryTDQuery.bos-query" alias.zh_TW="借款利息單分錄套打Query" desc.zh_TW="借款利息單分錄套打Query">
  7. <Params>
  8. <Param name="parentID">
  9. <Associate dataSourceID="LoanInterestHeaderTDQuery">id</Associate>
  10. </Param>
  11. </Params>
  12. </Reference>
  13. </DataSources>
  14. <Styles version="1.0">
  15. <Style id="3">
  16. <Borders>
  17. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
  18. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
  19. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
  20. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
  21. </Borders>
  22. <Alignment wrapText="true"/>
  23. </Style>
  24. <Style id="2">
  25. <Borders>
  26. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
  27. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
  28. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
  29. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
  30. </Borders>
  31. </Style>
  32. <Style id="10">
  33. <Borders>
  34. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
  35. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
  36. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
  37. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
  38. </Borders>
  39. <Alignment horizontal="left"/>
  40. </Style>
  41. <Style id="1">
  42. <Font size="12" bold="true" italic="false"/>
  43. </Style>
  44. <Style id="0"/>
  45. <Style id="7">
  46. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0"/>
  47. <Borders>
  48. <Border position="left" lineStyle="NullLine"/>
  49. <Border position="top" lineStyle="NullLine"/>
  50. <Border position="right" lineStyle="NullLine"/>
  51. <Border position="bottom" lineStyle="NullLine"/>
  52. <Border position="diagonalleft" lineStyle="NullLine"/>
  53. <Border position="diagonalright" lineStyle="NullLine"/>
  54. </Borders>
  55. <Interior color="#ffffff00" pattern="None" patternColor="#000000"/>
  56. <Alignment horizontal="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true"/>
  57. <Protection hidden="false" locked="false"/>
  58. <NumberFormat>0.00;-0.00</NumberFormat>
  59. </Style>
  60. <Style id="6">
  61. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0"/>
  62. <Borders>
  63. <Border position="left" lineStyle="NullLine"/>
  64. <Border position="top" lineStyle="NullLine"/>
  65. <Border position="right" lineStyle="NullLine"/>
  66. <Border position="bottom" lineStyle="NullLine"/>
  67. <Border position="diagonalleft" lineStyle="NullLine"/>
  68. <Border position="diagonalright" lineStyle="NullLine"/>
  69. </Borders>
  70. <Interior color="#ffffff00" pattern="None" patternColor="#000000"/>
  71. <Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true"/>
  72. <Protection hidden="false" locked="false"/>
  73. </Style>
  74. <Style id="5">
  75. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0"/>
  76. <Borders>
  77. <Border position="left" lineStyle="NullLine"/>
  78. <Border position="top" lineStyle="NullLine"/>
  79. <Border position="right" lineStyle="NullLine"/>
  80. <Border position="bottom" lineStyle="NullLine"/>
  81. <Border position="diagonalleft" lineStyle="NullLine"/>
  82. <Border position="diagonalright" lineStyle="NullLine"/>
  83. </Borders>
  84. <Interior color="#ffffff00" pattern="None" patternColor="#000000"/>
  85. <Alignment horizontal="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true"/>
  86. <Protection hidden="false" locked="false"/>
  87. <NumberFormat>0.00;-0.00</NumberFormat>
  88. </Style>
  89. <Style id="4">
  90. <Borders>
  91. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
  92. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
  93. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
  94. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
  95. </Borders>
  96. <Alignment wrapText="true"/>
  97. <NumberFormat>yyyy年m月d日;@</NumberFormat>
  98. </Style>
  99. <Style id="9">
  100. <Borders>
  101. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000"/>
  102. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000"/>
  103. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000"/>
  104. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000"/>
  105. </Borders>
  106. <Alignment wrapText="true"/>
  107. <NumberFormat>G/通用格式</NumberFormat>
  108. </Style>
  109. <Style id="8">
  110. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0"/>
  111. <Borders>
  112. <Border position="left" lineStyle="NullLine"/>
  113. <Border position="top" lineStyle="NullLine"/>
  114. <Border position="right" lineStyle="NullLine"/>
  115. <Border position="bottom" lineStyle="NullLine"/>
  116. <Border position="diagonalleft" lineStyle="NullLine"/>
  117. <Border position="diagonalright" lineStyle="NullLine"/>
  118. </Borders>
  119. <Interior color="#ffffff00" pattern="None" patternColor="#000000"/>
  120. <Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true"/>
  121. <Protection hidden="false" locked="false"/>
  122. </Style>
  123. <Style id="11">
  124. <Alignment wrapText="true"/>
  125. </Style>
  126. </Styles>
  127. <Report type="r1-print" version="7.0.1">
  128. <Page id="page1" width="1720" height="2470">
  129. <Sub-objects>
  130. <PrintLayoutGrid id="layoutGrid1" styleId="0" x="0" y="0" horizontalFill="true">
  131. <Data/>
  132. <Col width="287" id="column1" styleId="0"/>
  133. <Col width="287" id="column2" styleId="0"/>
  134. <Col width="287" id="column3" styleId="0"/>
  135. <Col width="287" id="column4" styleId="0"/>
  136. <Col width="286" id="column5" styleId="0"/>
  137. <Col width="286" id="column6" styleId="0"/>
  138. <TR height="140" id="row1" styleId="0">
  139. <TD id="cell1" styleId="1">
  140. <Value type="text"><![CDATA[借款利息單]]></Value>
  141. </TD>
  142. <TD id="cell2" styleId="0"/>
  143. <TD id="cell3" styleId="0"/>
  144. <TD id="cell46" styleId="0"/>
  145. <TD id="cell61" styleId="0"/>
  146. <TD id="cell76" styleId="0"/>
  147. </TR>
  148. <TR height="70" id="row2" styleId="0">
  149. <TD id="cell4" styleId="2">
  150. <Value type="text"><![CDATA[編號]]></Value>
  151. </TD>
  152. <TD id="cell5" styleId="3">
  153. <Value type="field" dataSource="LoanInterestHeaderTDQuery">number</Value>
  154. </TD>
  155. <TD id="cell6" styleId="2">
  156. <Value type="text"><![CDATA[日期]]></Value>
  157. </TD>
  158. <TD id="cell47" styleId="4">
  159. <Value type="field" dataSource="LoanInterestHeaderTDQuery">bizDate</Value>
  160. </TD>
  161. <TD id="cell62" styleId="2">
  162. <Value type="text"><![CDATA[類別]]></Value>
  163. </TD>
  164. <TD id="cell77" styleId="3">
  165. <Value type="field" dataSource="LoanInterestHeaderTDQuery">interestType</Value>
  166. </TD>
  167. </TR>
  168. <TR height="70" id="row3" styleId="0">
  169. <TD id="cell7" styleId="2">
  170. <Value type="text"><![CDATA[源貸款編號]]></Value>
  171. </TD>
  172. <TD id="cell8" styleId="3">
  173. <Value type="field" dataSource="LoanInterestHeaderTDQuery">loan.number</Value>
  174. </TD>
  175. <TD id="cell9" styleId="2">
  176. <Value type="text"><![CDATA[債權人]]></Value>
  177. </TD>
  178. <TD id="cell48" styleId="3">
  179. <Value type="field" dataSource="LoanInterestHeaderTDQuery">creditorAsBank.name</Value>
  180. </TD>
  181. <TD id="cell63" styleId="2">
  182. <Value type="text"><![CDATA[付息帳戶]]></Value>
  183. </TD>
  184. <TD id="cell78" styleId="3">
  185. <Value type="field" dataSource="LoanInterestHeaderTDQuery">account.name</Value>
  186. </TD>
  187. </TR>
  188. <TR height="70" id="row4" styleId="0">
  189. <TD id="cell10" styleId="2">
  190. <Value type="text"><![CDATA[計息開始日]]></Value>
  191. </TD>
  192. <TD id="cell11" styleId="3">
  193. <Value type="field" dataSource="LoanInterestHeaderTDQuery">beginDate</Value>
  194. </TD>
  195. <TD id="cell12" styleId="2">
  196. <Value type="text"><![CDATA[計息結束日]]></Value>
  197. </TD>
  198. <TD id="cell49" styleId="3">
  199. <Value type="field" dataSource="LoanInterestHeaderTDQuery">endDate</Value>
  200. </TD>
  201. <TD id="cell64" styleId="2">
  202. <Value type="text"><![CDATA[計息天數]]></Value>
  203. </TD>
  204. <TD id="cell79" styleId="3">
  205. <Value type="field" dataSource="LoanInterestHeaderTDQuery">days</Value>
  206. </TD>
  207. </TR>
  208. <TR height="70" id="row5" styleId="0">
  209. <TD id="cell13" styleId="2">
  210. <Value type="text"><![CDATA[逾期天數]]></Value>
  211. </TD>
  212. <TD id="cell14" styleId="3">
  213. <Value type="field" dataSource="LoanInterestHeaderTDQuery">daysOverdue</Value>
  214. </TD>
  215. <TD id="cell15" styleId="2">
  216. <Value type="text"><![CDATA[利率表示]]></Value>
  217. </TD>
  218. <TD id="cell50" styleId="3">
  219. <Value type="field" dataSource="LoanInterestHeaderTDQuery">intRateTypeExpression</Value>
  220. </TD>
  221. <TD id="cell65" styleId="2">
  222. <Value type="text"><![CDATA[利率]]></Value>
  223. </TD>
  224. <TD id="cell80" styleId="3">
  225. <Sub-objects>
  226. <PrintLayoutGrid id="layoutGrid2" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  227. <Data/>
  228. <Col width="220" id="column19"/>
  229. <Col width="64" id="column20"/>
  230. <TR height="68" id="row17">
  231. <TD id="cell109" styleId="5">
  232. <Value type="field" dataSource="LoanInterestHeaderTDQuery">intRate</Value>
  233. </TD>
  234. <TD id="cell110" styleId="6">
  235. <Script><![CDATA[var intRateTypeExpression = getFieldValue("LoanInterestHeaderTDQuery","intRateTypeExpression");
  236. if(intRateTypeExpression == "year" || intRateTypeExpression == "年" ){
  237. setValue("%");
  238. }
  239. else if(intRateTypeExpression == "month" || intRateTypeExpression == "day" || intRateTypeExpression == "月" || intRateTypeExpression == "日" ){
  240. setValue("‰");
  241. }]]></Script>
  242. </TD>
  243. </TR>
  244. </PrintLayoutGrid>
  245. </Sub-objects>
  246. </TD>
  247. </TR>
  248. <TR height="70" id="row6" styleId="0">
  249. <TD id="cell16" styleId="2">
  250. <Value type="text"><![CDATA[幣別]]></Value>
  251. </TD>
  252. <TD id="cell17" styleId="3">
  253. <Value type="field" dataSource="LoanInterestHeaderTDQuery">currency.name</Value>
  254. </TD>
  255. <TD id="cell18" styleId="2">
  256. <Value type="text"><![CDATA[匯率]]></Value>
  257. </TD>
  258. <TD id="cell51" styleId="3">
  259. <Value type="field" dataSource="LoanInterestHeaderTDQuery">exchange</Value>
  260. </TD>
  261. <TD id="cell66" styleId="2">
  262. <Value type="text"><![CDATA[計息本金]]></Value>
  263. </TD>
  264. <TD id="cell81" styleId="3">
  265. <Value type="field" dataSource="LoanInterestHeaderTDQuery">amount</Value>
  266. </TD>
  267. </TR>
  268. <TR height="70" id="row7" styleId="0">
  269. <TD id="cell19" styleId="2">
  270. <Value type="text"><![CDATA[應計利息]]></Value>
  271. </TD>
  272. <TD id="cell20" styleId="3">
  273. <Value type="field" dataSource="LoanInterestHeaderTDQuery">interest</Value>
  274. </TD>
  275. <TD id="cell21" styleId="2">
  276. <Value type="text"><![CDATA[實計利息]]></Value>
  277. </TD>
  278. <TD id="cell52" styleId="3">
  279. <Value type="field" dataSource="LoanInterestHeaderTDQuery">realInterest</Value>
  280. </TD>
  281. <TD id="cell67" styleId="2">
  282. <Value type="text"><![CDATA[罰息方式]]></Value>
  283. </TD>
  284. <TD id="cell82" styleId="3">
  285. <Value type="field" dataSource="LoanInterestHeaderTDQuery">punishIntType</Value>
  286. </TD>
  287. </TR>
  288. <TR height="70" id="row8" styleId="0">
  289. <TD id="cell22" styleId="2">
  290. <Value type="text"><![CDATA[罰息率]]></Value>
  291. </TD>
  292. <TD id="cell23" styleId="3">
  293. <Script><![CDATA[var punishIntType = getFieldValue("LoanInterestHeaderTDQuery","punishIntType");
  294. if(punishIntType == "addPercent"){
  295. setValue("%");
  296. }
  297. else if(punishIntType == "addaccrual"){
  298. setValue("‰");
  299. }]]></Script>
  300. <Sub-objects>
  301. <PrintLayoutGrid id="layoutGrid4" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  302. <Data/>
  303. <Col width="212" id="column23"/>
  304. <Col width="73" id="column24"/>
  305. <TR height="68" id="row19">
  306. <TD id="cell113" styleId="7">
  307. <Value type="field" dataSource="LoanInterestHeaderTDQuery">punishIntRate</Value>
  308. </TD>
  309. <TD id="cell114" styleId="8">
  310. <Script><![CDATA[var punishIntType = getFieldValue("LoanInterestHeaderTDQuery","punishIntType");
  311. if(punishIntType == "addPercent" || punishIntType == "加点"){
  312. setValue("%");
  313. }
  314. else if(punishIntType == "addaccrual" || punishIntType == "加息"){
  315. setValue("‰");
  316. }]]></Script>
  317. </TD>
  318. </TR>
  319. </PrintLayoutGrid>
  320. </Sub-objects>
  321. </TD>
  322. <TD id="cell24" styleId="2">
  323. <Value type="text"><![CDATA[應計罰息]]></Value>
  324. </TD>
  325. <TD id="cell53" styleId="3">
  326. <Value type="field" dataSource="LoanInterestHeaderTDQuery">punishInterest</Value>
  327. </TD>
  328. <TD id="cell68" styleId="2">
  329. <Value type="text"><![CDATA[實計罰息]]></Value>
  330. </TD>
  331. <TD id="cell83" styleId="3">
  332. <Value type="field" dataSource="LoanInterestHeaderTDQuery">realPunishInterest</Value>
  333. </TD>
  334. </TR>
  335. <TR height="70" id="row9" styleId="0">
  336. <TD id="cell25" styleId="2">
  337. <Value type="text"><![CDATA[沖帳金額]]></Value>
  338. </TD>
  339. <TD id="cell26" styleId="9">
  340. <Value type="field" dataSource="LoanInterestHeaderTDQuery">strikeAmount</Value>
  341. </TD>
  342. <TD id="cell27" styleId="2">
  343. <Value type="text"><![CDATA[預算專案]]></Value>
  344. </TD>
  345. <TD id="cell54" styleId="3">
  346. <Value type="field" dataSource="LoanInterestHeaderTDQuery">outBgItemName</Value>
  347. </TD>
  348. <TD id="cell69" styleId="2">
  349. <Value type="text"><![CDATA[利息費用科目]]></Value>
  350. </TD>
  351. <TD id="cell84" styleId="3">
  352. <Value type="field" dataSource="LoanInterestHeaderTDQuery">intFeeAcctView.name</Value>
  353. </TD>
  354. </TR>
  355. <TR height="70" id="row10" styleId="0">
  356. <TD id="cell28" styleId="2">
  357. <Value type="text"><![CDATA[出納]]></Value>
  358. </TD>
  359. <TD id="cell29" styleId="3">
  360. <Value type="field" dataSource="LoanInterestHeaderTDQuery">cashier.name</Value>
  361. </TD>
  362. <TD id="cell30" styleId="2">
  363. <Value type="text"><![CDATA[摘要]]></Value>
  364. </TD>
  365. <TD id="cell55" styleId="3">
  366. <Value type="field" dataSource="LoanInterestHeaderTDQuery">description</Value>
  367. </TD>
  368. <TD id="cell70" styleId="2"/>
  369. <TD id="cell85" styleId="2"/>
  370. </TR>
  371. <TR height="70" id="row11" styleId="0">
  372. <TD id="cell31" styleId="2">
  373. <Value type="text"><![CDATA[項目]]></Value>
  374. </TD>
  375. <TD id="cell32" styleId="3">
  376. <Value type="field" dataSource="LoanInterestHeaderTDQuery">project.name</Value>
  377. </TD>
  378. <TD id="cell33" styleId="2"/>
  379. <TD id="cell56" styleId="2"/>
  380. <TD id="cell71" styleId="2"/>
  381. <TD id="cell86" styleId="2"/>
  382. </TR>
  383. <TR height="70" id="row12" styleId="0">
  384. <TD id="cell34" styleId="10">
  385. <Value type="text"><![CDATA[分段計息明細]]></Value>
  386. </TD>
  387. <TD id="cell35" styleId="2"/>
  388. <TD id="cell36" styleId="2"/>
  389. <TD id="cell57" styleId="2"/>
  390. <TD id="cell72" styleId="2"/>
  391. <TD id="cell87" styleId="2"/>
  392. </TR>
  393. <TR height="140" id="row13" styleId="0" autoAdjustHeight="true">
  394. <TD id="cell37" styleId="0">
  395. <Sub-objects>
  396. <PrintDataGrid id="dataGrid1" styleId="0" x="0" y="0" horizontalFill="true">
  397. <Data dataSource="LoanInterestEntryTDQuery"/>
  398. <Col width="144" id="column7" styleId="0"/>
  399. <Col width="144" id="column8" styleId="0"/>
  400. <Col width="143" id="column9" styleId="0"/>
  401. <Col width="143" id="column10" styleId="0"/>
  402. <Col width="143" id="column11" styleId="0"/>
  403. <Col width="192" id="column12" styleId="0"/>
  404. <Col width="94" id="column13" styleId="0"/>
  405. <Col width="143" id="column14" styleId="0"/>
  406. <Col width="143" id="column15" styleId="0"/>
  407. <Col width="143" id="column16" styleId="0"/>
  408. <Col width="177" id="column17" styleId="0"/>
  409. <Col width="109" id="column18" styleId="0"/>
  410. <TR height="70" type="normal" id="row15" styleId="11">
  411. <TD id="cell43" styleId="3">
  412. <Value type="text"><![CDATA[單據分錄序號]]></Value>
  413. </TD>
  414. <TD id="cell44" styleId="3">
  415. <Value type="text"><![CDATA[計息開始日]]></Value>
  416. </TD>
  417. <TD id="cell45" styleId="3">
  418. <Value type="text"><![CDATA[計息結束日]]></Value>
  419. </TD>
  420. <TD id="cell91" styleId="3">
  421. <Value type="text"><![CDATA[計息天數]]></Value>
  422. </TD>
  423. <TD id="cell93" styleId="3">
  424. <Value type="text"><![CDATA[計息本金]]></Value>
  425. </TD>
  426. <TD id="cell95" styleId="3">
  427. <Value type="text"><![CDATA[利率]]></Value>
  428. </TD>
  429. <TD id="cell97" styleId="3">
  430. <Value type="text"><![CDATA[利率表示]]></Value>
  431. </TD>
  432. <TD id="cell99" styleId="3">
  433. <Value type="text"><![CDATA[折算天數]]></Value>
  434. </TD>
  435. <TD id="cell101" styleId="3">
  436. <Value type="text"><![CDATA[應計利息]]></Value>
  437. </TD>
  438. <TD id="cell103" styleId="3">
  439. <Value type="text"><![CDATA[逾期天數]]></Value>
  440. </TD>
  441. <TD id="cell105" styleId="3">
  442. <Value type="text"><![CDATA[罰息率/日加息率]]></Value>
  443. </TD>
  444. <TD id="cell107" styleId="3">
  445. <Value type="text"><![CDATA[應計罰息]]></Value>
  446. </TD>
  447. </TR>
  448. <TR height="70" type="detail" autoAdjustHeight="true" id="row16" styleId="11">
  449. <TD id="cell60" styleId="3">
  450. <Value type="field">seq</Value>
  451. </TD>
  452. <TD id="cell75" styleId="3">
  453. <Value type="field">beginDate</Value>
  454. </TD>
  455. <TD id="cell90" styleId="3">
  456. <Value type="field">endDate</Value>
  457. </TD>
  458. <TD id="cell92" styleId="3">
  459. <Value type="field">days</Value>
  460. </TD>
  461. <TD id="cell94" styleId="3">
  462. <Value type="field">amount</Value>
  463. </TD>
  464. <TD id="cell96" styleId="3">
  465. <Sub-objects>
  466. <PrintLayoutGrid id="layoutGrid3" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  467. <Data/>
  468. <Col width="143" id="column21"/>
  469. <Col width="47" id="column22"/>
  470. <TR height="68" id="row18">
  471. <TD id="cell111" styleId="7">
  472. <Value type="field" dataSource="LoanInterestEntryTDQuery">intRate</Value>
  473. </TD>
  474. <TD id="cell112" styleId="8">
  475. <Script><![CDATA[var intRateTypeExpression = getFieldValue("LoanInterestEntryTDQuery","intRateTypeExpression");
  476. if(intRateTypeExpression == "year" || intRateTypeExpression == "年"){
  477. setValue("%");
  478. }
  479. else if(intRateTypeExpression == "month" || intRateTypeExpression == "day"|| intRateTypeExpression == "月" || intRateTypeExpression == "日"){
  480. setValue("‰");
  481. }
  482. ]]></Script>
  483. </TD>
  484. </TR>
  485. </PrintLayoutGrid>
  486. </Sub-objects>
  487. </TD>
  488. <TD id="cell98" styleId="3">
  489. <Script><![CDATA[switch(getValue()){
  490. case "year":setValue("年");break;
  491. case "month":setValue("月");break;
  492. case "day":setValue("日");break;
  493. }]]></Script>
  494. <Value type="field">intRateTypeExpression</Value>
  495. </TD>
  496. <TD id="cell100" styleId="3">
  497. <Value type="field">yearDays</Value>
  498. </TD>
  499. <TD id="cell102" styleId="3">
  500. <Value type="field">interest</Value>
  501. </TD>
  502. <TD id="cell104" styleId="3">
  503. <Value type="field">daysOverdue</Value>
  504. </TD>
  505. <TD id="cell106" styleId="3">
  506. <Sub-objects>
  507. <PrintLayoutGrid id="layoutGrid5" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  508. <Data/>
  509. <Col width="120" id="column25"/>
  510. <Col width="55" id="column26"/>
  511. <TR height="68" id="row20">
  512. <TD id="cell115" styleId="7">
  513. <Value type="field" dataSource="LoanInterestEntryTDQuery">punishIntRate</Value>
  514. </TD>
  515. <TD id="cell116" styleId="8">
  516. <Script><![CDATA[var punishIntType = getFieldValue("LoanInterestHeaderTDQuery","punishIntType");
  517. if(punishIntType == "addPercent" || punishIntType == "加点" ){
  518. setValue("%");
  519. }
  520. else if(punishIntType == "addaccrual" || punishIntType == "加息"){
  521. setValue("‰");
  522. }]]></Script>
  523. </TD>
  524. </TR>
  525. </PrintLayoutGrid>
  526. </Sub-objects>
  527. </TD>
  528. <TD id="cell108" styleId="3">
  529. <Value type="field">punishInterest</Value>
  530. </TD>
  531. </TR>
  532. </PrintDataGrid>
  533. </Sub-objects>
  534. </TD>
  535. <TD id="cell38" styleId="0"/>
  536. <TD id="cell39" styleId="0"/>
  537. <TD id="cell58" styleId="0"/>
  538. <TD id="cell73" styleId="0"/>
  539. <TD id="cell88" styleId="0"/>
  540. </TR>
  541. <TR height="70" id="row14" styleId="0">
  542. <TD id="cell40" styleId="2">
  543. <Value type="text"><![CDATA[制單]]></Value>
  544. </TD>
  545. <TD id="cell41" styleId="3">
  546. <Value type="field" dataSource="LoanInterestHeaderTDQuery">creator.name</Value>
  547. </TD>
  548. <TD id="cell42" styleId="2">
  549. <Value type="text"><![CDATA[會計]]></Value>
  550. </TD>
  551. <TD id="cell59" styleId="3">
  552. <Value type="field" dataSource="LoanInterestHeaderTDQuery">accountant.name</Value>
  553. </TD>
  554. <TD id="cell74" styleId="2">
  555. <Value type="text"><![CDATA[制單組織]]></Value>
  556. </TD>
  557. <TD id="cell89" styleId="3">
  558. <Value type="field" dataSource="LoanInterestHeaderTDQuery">company.name</Value>
  559. </TD>
  560. </TR>
  561. <MergeBlocks>
  562. <Block left="0" right="5" top="0" bottom="0"/>
  563. <Block left="3" right="5" top="9" bottom="9"/>
  564. <Block left="1" right="5" top="10" bottom="10"/>
  565. <Block left="0" right="5" top="11" bottom="11"/>
  566. <Block left="0" right="5" top="12" bottom="12"/>
  567. </MergeBlocks>
  568. </PrintLayoutGrid>
  569. </Sub-objects>
  570. </Page>
  571. </Report>
  572. <PrintInfo>
  573. <PaperSetup>
  574. <Paper>iso-a4</Paper>
  575. <Orientation>PORTRAIT</Orientation>
  576. <PageMargin left="190" right="190" top="250" bottom="250"/>
  577. <Header height="150" margin="100"/>
  578. <Footer height="150" margin="100"/>
  579. </PaperSetup>
  580. <PrinterSetup>
  581. <DynamicPaper>false</DynamicPaper>
  582. <EconomizePaper isVerEconomizePaper="false" verSpace="0" isHorEconomizePaper="false" horSpace="0"/>
  583. </PrinterSetup>
  584. <PreviewSetup>
  585. <BackgroundPicture>false</BackgroundPicture>
  586. </PreviewSetup>
  587. </PrintInfo>
  588. </DocRoot>